Georgia and Florida Reopening Among COVID-19 Concerns¶

Applied Data Science Capstone by IBM/Coursera¶

Table of Contents¶

Introduction
Methodology
Results
Discussion
Conclusion
Appendix

Introduction/Business Problem¶

There are cities like Jacksonville reopening beaches while Georgia is planning to reopen several businesses starting April 24th. Is this a good time to consider reopening with the risk to public health from COVID-19 or will there be too much economic damage if not? In order to answer the questions, I will take a look at county health population information from https://www.countyhealthrankings.org/ and business information(leveraging Foursquare API)in Jacksonsville, Florida and compare to Savannah, Georgia since they are large cities located in the neighboring states. The governers of Georgia and Florida should take these factors into consideration before opening their states among COVID-19.

Data¶

I. Neighborhood Locations
I will be using http://www.city-data.com to get neighborhoods and geographical locations.

II. Foursquare Location API
I will explore business information such as number and type of businesses to see the type of impact closing the cities will have. I also want to see if there are nearby clinics, hospitals, and/or pharmacies to learn about capacity for handling rise in cases for decision in reopening.

III. County Health Rankings
I will be using county health rankings to get details about the population using information such as:

Quality of Life
Health Behaviors
Clinical Care
Social & Economic Factors

IV. Death Rates by Age
I will be using https://www.worldometers.info/coronavirus/coronavirus-age-sex-demographics/ to get death rates by age.

V. Hospital Capacities
I will be using https://coronavirus.jhu.edu/us-map to get deaths, confirmed cases, and hospital capacity by county.

Methodology¶

I. Access Foursquare API
In order to determine number and/or type of businesses affected, we need to explore Jacksonville and Savannah counties. We will access the Foursquare API to get business information but first need to find all the nearby neighborhoods with geographical coordinates in each city.

Import necessary packages and libraries.

import numpy as np # library to handle data in a vectorized manner

import pandas as pd # library for data analsysis
pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)

import json # library to handle JSON files

!conda install -c conda-forge geopy --yes # uncomment this line if you haven't completed the Foursquare API lab
from geopy.geocoders import Nominatim # convert an address into latitude and longitude values

import requests # library to handle requests
from pandas.io.json import json_normalize # tranform JSON file into a pandas dataframe

# Matplotlib and associated plotting modules
import matplotlib.cm as cm
import matplotlib.colors as colors

# import k-means from clustering stage
from sklearn.cluster import KMeans

print('Libraries imported.')

conda update -n base conda

# conda install -c anaconda beautifulsoup4

import requests
from bs4 import BeautifulSoup
from requests import get
from requests.exceptions import RequestException
from contextlib import closing
import re

Generate credentials to access API.

CLIENT_ID = 'KTOGVYYQUEWMCLZYN3EHY3W1FJ2EUDJ1FIXZKSXQCWBXNQJA' # your Foursquare ID
CLIENT_SECRET = '01RRALCQSNM3UZKYRWZYBNMJL5O5TBFCCBRVKYI4XUA0MSWW' # your Foursquare Secret
VERSION = '20180604'
LIMIT = 30
print('Your credentails:')
print('CLIENT_ID: ' + CLIENT_ID)
print('CLIENT_SECRET:' + CLIENT_SECRET)

Your credentails:
CLIENT_ID: KTOGVYYQUEWMCLZYN3EHY3W1FJ2EUDJ1FIXZKSXQCWBXNQJA
CLIENT_SECRET:01RRALCQSNM3UZKYRWZYBNMJL5O5TBFCCBRVKYI4XUA0MSWW

Create function for getting neighborhood coordinates by city. The function webscrapes city-data.com to get neighborhood information by city.

def get_neigborhood(URL,city):
#     URL = 'http://www.city-data.com/nbmaps/neigh-Savannah-Georgia.html'
    page = requests.get(URL)
    soup = BeautifulSoup(page.content, 'html.parser') 
    city_name = [tag.text for tag in soup.find_all('a',href=re.compile(r'#N\d+'))] 
    string=(','+ city)
    city_names=[x + string for x in city_name]
    column_names = ['Neighborhood', 'Latitude', 'Longitude'] 
    # instantiate the dataframe
    neighborhoods = pd.DataFrame(columns=column_names)
    #apply Nominatim
    geolocator = Nominatim(user_agent="to_explorer")
 
    for i in city_names:
        try:
            location = geolocator.geocode(i)
            latitude = location.latitude 
            longitude = location.longitude 
            neighborhoods = neighborhoods.append({'Neighborhood': i,
                                          'Latitude': latitude,
                                          'Longitude': longitude}, ignore_index=True)  
        except AttributeError:
            continue 

    # making separate first name column from new data frame 
    new = neighborhoods["Neighborhood"].str.split(",", n = 1, expand = True) 
    neighborhoods["Neighborhood"]= new[0] 
  
    # making separate last name column from new data frame 
    neighborhoods["City"]= new[1] 
    neighborhoods2 = neighborhoods[["City", "Neighborhood", "Latitude","Longitude"]]


    return neighborhoods2

Call function by city to get all neighborhoods, latitude,and longitude.
Let's start with Savannah.

Jacksonville='http://www.city-data.com/nbmaps/neigh-Jacksonville-Florida.html'
Savannah='http://www.city-data.com/nbmaps/neigh-Savannah-Georgia.html'
neighborhoods=get_neigborhood(Jacksonville,city='Jacksonville')
# neighborhoods=get_neigborhood(Savannah,city='Savannah')
# 'http://www.city-data.com/nbmaps/neigh-Jacksonville-Florida.html',city='Jacksonville'

neighborhoods.head()

Next Jacksonville neighborhoods and coordinates.

neighborhoods.head()

Use function to get nearby venues.

def getNearbyVenues(names, latitudes, longitudes, radius=1000):
    
    venues_list=[]
    for name, lat, lng in zip(names, latitudes, longitudes):
        print(name)
            
        # create the API request URL
        url = 'https://api.foursquare.com/v2/venues/explore?&client_id={}&client_secret={}&v={}&ll={},{}&radius={}&limit={}'.format(
            CLIENT_ID, 
            CLIENT_SECRET, 
            VERSION, 
            lat, 
            lng, 
            radius, 
            LIMIT)
            
        # make the GET request
        results = requests.get(url).json()["response"]['groups'][0]['items']
        
        # return only relevant information for each nearby venue
        venues_list.append([(
            name, 
            lat, 
            lng, 
            v['venue']['name'], 
            v['venue']['location']['lat'], 
            v['venue']['location']['lng'],  
            v['venue']['categories'][0]['name']) for v in results])

    nearby_venues = pd.DataFrame([item for venue_list in venues_list for item in venue_list])
    nearby_venues.columns = ['Neighborhood', 
                  'Neighborhood Latitude', 
                  'Neighborhood Longitude', 
                  'Venue', 
                  'Venue Latitude', 
                  'Venue Longitude', 
                  'Venue Category']
    
    return(nearby_venues)

Create simple variable to assign different cities.

A='Savannah'

A_venues = getNearbyVenues(names=neighborhoods['Neighborhood'],
                                   latitudes=neighborhoods['Latitude'],
                                   longitudes=neighborhoods['Longitude']
                                  )

A_venues.head()

A='Jacksonville'
A_venues = getNearbyVenues(names=neighborhoods['Neighborhood'],
                                   latitudes=neighborhoods['Latitude'],
                                   longitudes=neighborhoods['Longitude']
                                  )

Arlington
Avondale
Belfort Station
Brooklyn
Church District
Downtown
East Jacksonville
Empire Point
Mandarin
North Jacksonville
Oakland
Ortega
River Park
Riverside
San Marco
Sherwood Forest
South Jacksonville
South Side
Springfield
Stadium District
Waterleaf
West Jacksonville

A_venues.groupby('Neighborhood').count()
print('There are {} uniques categories.'.format(len(A_venues['Venue Category'].unique())))

There are 193 uniques categories.

A_venues.groupby('Neighborhood').count()
print('There are {} uniques categories.'.format(len(A_venues['Venue Category'].unique())))

There are 140 uniques categories.

One-hot Encoding for Generating Venue Frequency

# one hot encoding
A_onehot = pd.get_dummies(A_venues[['Venue Category']], prefix="", prefix_sep="")

# add neighborhood column back to dataframe
A_onehot['Neighborhood'] = A_venues['Neighborhood'] 

# move neighborhood column to the first column
fixed_columns = [A_onehot.columns[-1]] + list(A_onehot.columns[:-1])
A_onehot = A_onehot[fixed_columns]

A_onehot.head()

# one hot encoding
A_onehot = pd.get_dummies(A_venues[['Venue Category']], prefix="", prefix_sep="")

# add neighborhood column back to dataframe
A_onehot['Neighborhood'] = A_venues['Neighborhood'] 

# move neighborhood column to the first column
fixed_columns = [A_onehot.columns[-1]] + list(A_onehot.columns[:-1])
A_onehot = A_onehot[fixed_columns]

A_onehot.head()

#Savannah
A_grouped = A_onehot.groupby('Neighborhood').mean().reset_index()
A_grouped.head()

#Jacksonville
A_grouped = A_onehot.groupby('Neighborhood').mean().reset_index()
A_grouped.head()

Savannah Venue Frequency¶

num_top_venues = 10
for hood in A_grouped['Neighborhood']:
    print("----"+hood+"----")
    temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
    temp.columns = ['venue','freq']
    temp = temp.iloc[1:]
    temp['freq'] = temp['freq'].astype(float)
    temp = temp.round({'freq': 2})
    print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
    print('\n')

In East Savannah, pizza places(18%) and discount stores(18%) account for 36% of venues. In Southover, Savannah bakeries(25%), breweries(25%), and discount stores(25%) account for 75% of venues.

For output go to Savannah_Venue

Jacksonville Venue Frequency¶

num_top_venues = 10
for hood in A_grouped['Neighborhood']:
    print("----"+hood+"----")
    temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
    temp.columns = ['venue','freq']
    temp = temp.iloc[1:]
    temp['freq'] = temp['freq'].astype(float)
    temp = temp.round({'freq': 2})
    print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
    print('\n')

In North Jacksonville and East Jacksonville, fast food restaurants account for about 38% of venues. In East Savannah, pizza places(18%) and discount stores(18%) account for 36% of venues. In Southover, Savannah bakeries(25%), breweries(25%), and discount stores(25%) account for 75% of venues.

For output go to Jacksonville_Venue

Get most common revenues and place in dataframe.

def return_most_common_venues(row, num_top_venues):
    row_categories = row.iloc[1:]
    row_categories_sorted = row_categories.sort_values(ascending=False)
    
    return row_categories_sorted.index.values[0:num_top_venues]

Savannah Top 10 Revenues

num_top_venues = 10

indicators = ['st', 'nd', 'rd']

# create columns according to number of top venues
columns = ['Neighborhood']
for ind in np.arange(num_top_venues):
    try:
        columns.append('{}{} Most Common Venue'.format(ind+1, indicators[ind]))
    except:
        columns.append('{}th Most Common Venue'.format(ind+1))

# create a new dataframe
A_neighborhoods_venues_sorted = pd.DataFrame(columns=columns)
A_neighborhoods_venues_sorted['Neighborhood'] = A_grouped['Neighborhood']

for ind in np.arange(A_grouped.shape[0]):
    A_neighborhoods_venues_sorted.iloc[ind, 1:] = return_most_common_venues(A_grouped.iloc[ind, :], num_top_venues)

A_neighborhoods_venues_sorted.head(10)

Jacksonville Top 10 Revenues

#Jacksonville
num_top_venues = 10

indicators = ['st', 'nd', 'rd']

# create columns according to number of top venues
columns = ['Neighborhood']
for ind in np.arange(num_top_venues):
    try:
        columns.append('{}{} Most Common Venue'.format(ind+1, indicators[ind]))
    except:
        columns.append('{}th Most Common Venue'.format(ind+1))

# create a new dataframe
A_neighborhoods_venues_sorted = pd.DataFrame(columns=columns)
A_neighborhoods_venues_sorted['Neighborhood'] = A_grouped['Neighborhood']

for ind in np.arange(A_grouped.shape[0]):
    A_neighborhoods_venues_sorted.iloc[ind, 1:] = return_most_common_venues(A_grouped.iloc[ind, :], num_top_venues)

A_neighborhoods_venues_sorted.head(10)

Read CSV Files with Table Information

pip install xlrd

Collecting xlrd
  Downloading xlrd-1.2.0-py2.py3-none-any.whl (103 kB)
     |████████████████████████████████| 103 kB 3.6 MB/s eta 0:00:01
Installing collected packages: xlrd
Successfully installed xlrd-1.2.0
Note: you may need to restart the kernel to use updated packages.

pwd

'/home/jovyan/demo'

import pandas as pd
County_Table= pd.read_csv('/home/jovyan/demo/County_Health_Rankings.csv')

Import County Health Rankings Table
Reference:https://www.countyhealthrankings.org/app/georgia/2020/compare/snapshot?counties=12_031%2013_051

County_Table[County_Table.isnull()]=""
County_Table.head()

Import Death by Age Table
Reference:https://www.worldometers.info/coronavirus/coronavirus-age-sex-demographics/
As of May 13th

Death_by_Age_Table= pd.read_csv('/home/jovyan/demo/Death_By_Age_Coronavirus.csv')

Import Fatalaties and Hospital Capacities
Reference:https://bao.arcgis.com/covid-19/jhu/county/13051.html

Capacity_Table= pd.read_csv('/home/jovyan/demo/Hospital_Capacity.csv')

Results¶

Table 1. Savannah Venues

Savannah_data=A_neighborhoods_venues_sorted
Savannah_data

Table 2. Jacksonville Venues

Jacksonville_data=A_neighborhoods_venues_sorted
Jacksonville_data

Table 3. County Health Rankings
Reference: https://www.countyhealthrankings.org/app/georgia/2020/compare/snapshot?counties=12_031%2013_051

County_Table

Table 4. Death by Age New York
Reference:https://www.worldometers.info/coronavirus/coronavirus-age-sex-demographics/

Death_by_Age_Table

Table 5. Capacity and Fatality Rates
Reference:https://bao.arcgis.com/covid-19/jhu/county/13051.html

Capacity_Table

For all rates by county go to: Capacity

Discussion¶

Based on venues in Savannah(Table 1) and Jacksonville(Table 2) there are many businesses/venues that will be significantly impacted by economic shutdown. In North Jacksonville and East Jacksonville, fast food restaurants account for about 38% of venues. In East Savannah, pizza places(18%) and discount stores(18%) account for 36% of venues while in Southover, Savannah bakeries(25%), breweries(25%), and discount stores(25%) account for 75% of venues. With so many businesses impacted will reopening be risky? If we take a look at county health rankings(Table 3), only 14-15% of the population is 65 and over indicating a small high-risk population(Table 4) with about 75% of deaths occurring in people 65+. Additionally, access to exercise opportunities are about 90% indicating the ability for most of the population to engage in immune and health boosting activities which is important to improve the obesity rate at 31%. However, we do need to factor in smoking at 20% which increases the risk for complications for Coronavirus. Is there medical capacity for handling increase in cases? According to Johns Hopkins University, capacity and fatality rates(Table 5), Duval and Chatham counties fall well below the averages of Queens, New York. Although New York was initial site, at this point Jacksonville and Savannah have relatively low numbers of infections with a significant number of beds available.

Conclusion¶

The governors of Jacksonville and Savannah should consider the pros and cons of opening up too soon. As Table 5 indicates, the rate of infections and fatalities are relatively low especially for Duval county of Jacksonville. Chatham county has a higher rate but still half of Queens, New York which is the epicenter of the virus. With a population of about 300K, Chatham may fare better than other counties because of the relatively small population and vulnerable population at approximately 15%(65+). Governors have considered opening places at 25% capacity but many businesses can't be profitable at such low capacity. Another suggestion is perhaps sustain stay-at-home orders for vulnerable populations. Businesses like gyms may significantly lower the risks by permitting those under 65 at full capacity with significant cleaning measures. For schools, the most vulnerable populations continue to work online while the least can go back to the classroom. Allow the least vulnerable populations to get back to work and subsidize the ones that need to stay at home.

Appendix¶

All Savannah Neighborhoods¶

neighborhoods

All Jacksonville Neighborhoods¶

neighborhoods

Savannah Venue Frequency¶

num_top_venues = 10
for hood in A_grouped['Neighborhood']:
    print("----"+hood+"----")
    temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
    temp.columns = ['venue','freq']
    temp = temp.iloc[1:]
    temp['freq'] = temp['freq'].astype(float)
    temp = temp.round({'freq': 2})
    print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
    print('\n')

----Avalon----
                  venue  freq
0    Chinese Restaurant  0.07
1           Pizza Place  0.07
2    Mexican Restaurant  0.07
3     Mobile Phone Shop  0.07
4        Sandwich Place  0.07
5   Fried Chicken Joint  0.03
6  Gym / Fitness Center  0.03
7         Grocery Store  0.03
8      Greek Restaurant  0.03
9         Deli / Bodega  0.03


----Avondale----
                  venue  freq
0                  Food  0.14
1                  Park  0.14
2          Intersection  0.07
3         Historic Site  0.07
4        General Travel  0.07
5          Skating Rink  0.07
6    Seafood Restaurant  0.07
7          Liquor Store  0.07
8         Tour Provider  0.07
9  Fast Food Restaurant  0.07


----Baldwin Park----
                             venue  freq
0                      Gas Station  0.10
1                             Park  0.10
2                     Intersection  0.07
3  Southern / Soul Food Restaurant  0.07
4              American Restaurant  0.07
5                       Playground  0.07
6                     Antique Shop  0.03
7                      Coffee Shop  0.03
8              Sporting Goods Shop  0.03
9        Middle Eastern Restaurant  0.03


----Bartow----
                   venue  freq
0         Discount Store   0.2
1              Pet Store   0.2
2     Seafood Restaurant   0.1
3    American Restaurant   0.1
4                   Park   0.1
5     Chinese Restaurant   0.1
6          Grocery Store   0.1
7         Shipping Store   0.1
8  Outdoors & Recreation   0.0
9          Moving Target   0.0


----Bayview----
                        venue  freq
0                      Garden  0.25
1  Construction & Landscaping  0.25
2                  Kids Store  0.25
3            Drive-in Theater  0.25
4                 Pizza Place  0.00
5       Outdoors & Recreation  0.00
6           Mobile Phone Shop  0.00
7               Moving Target  0.00
8                   Multiplex  0.00
9                      Museum  0.00


----Beach Institute----
                venue  freq
0               Plaza  0.23
1                Park  0.07
2     Bed & Breakfast  0.07
3  Italian Restaurant  0.03
4      Farmers Market  0.03
5              Museum  0.03
6      Breakfast Spot  0.03
7            Fountain  0.03
8            Tea Room  0.03
9      History Museum  0.03


----Berkshire Woods----
                       venue  freq
0                       Park   0.4
1               Home Service   0.2
2         Photography Studio   0.2
3                Coffee Shop   0.2
4                Yoga Studio   0.0
5               Optical Shop   0.0
6  Middle Eastern Restaurant   0.0
7          Mobile Phone Shop   0.0
8              Moving Target   0.0
9                  Multiplex   0.0


----Bingville----
                   venue  freq
0      Convenience Store  0.13
1                   Park  0.13
2         Discount Store  0.09
3                    Bar  0.04
4      Electronics Store  0.04
5   Fast Food Restaurant  0.04
6     Seafood Restaurant  0.04
7            Coffee Shop  0.04
8     Chinese Restaurant  0.04
9  Outdoors & Recreation  0.04


----Blueberry Hill----
                       venue  freq
0                       Farm   1.0
1                Yoga Studio   0.0
2                IT Services   0.0
3  Middle Eastern Restaurant   0.0
4          Mobile Phone Shop   0.0
5              Moving Target   0.0
6                  Multiplex   0.0
7                     Museum   0.0
8    New American Restaurant   0.0
9                  Nightclub   0.0


----Brookview----
                             venue  freq
0                     Intersection  0.18
1               Chinese Restaurant  0.18
2           Thrift / Vintage Store  0.09
3  Southern / Soul Food Restaurant  0.09
4           Furniture / Home Store  0.09
5                      Golf Course  0.09
6       Construction & Landscaping  0.09
7                Food & Drink Shop  0.09
8                             Food  0.09
9                        Multiplex  0.00


----Cann Park----
                    venue  freq
0                  Bakery  0.10
1            Intersection  0.07
2          Discount Store  0.07
3      Chinese Restaurant  0.07
4      Seafood Restaurant  0.07
5       Convenience Store  0.07
6                    Park  0.07
7                     Bar  0.03
8  Thrift / Vintage Store  0.03
9       Mobile Phone Shop  0.03


----Carver Heights----
                 venue  freq
0          Coffee Shop  0.10
1  American Restaurant  0.07
2           Restaurant  0.07
3   Seafood Restaurant  0.07
4                 Park  0.07
5                 Café  0.07
6          Yoga Studio  0.03
7           Beer Store  0.03
8           Playground  0.03
9       Farmers Market  0.03


----Chatham Crescent----
                       venue  freq
0        American Restaurant  0.07
1               Antique Shop  0.07
2         Seafood Restaurant  0.07
3                       Café  0.07
4  Middle Eastern Restaurant  0.03
5                        Spa  0.03
6                    Brewery  0.03
7                      Plaza  0.03
8               Burger Joint  0.03
9           Greek Restaurant  0.03


----Chatham Parkway----
                  venue  freq
0                   Gym  0.22
1             Gun Range  0.11
2    Italian Restaurant  0.11
3   Japanese Restaurant  0.11
4         Jewelry Store  0.11
5        Breakfast Spot  0.11
6        Sandwich Place  0.11
7  Fast Food Restaurant  0.11
8          Noodle House  0.00
9          Optical Shop  0.00


----Chippewa----
                    venue  freq
0          Cosmetics Shop  0.10
1        Department Store  0.10
2          Lingerie Store  0.10
3  Furniture / Home Store  0.07
4           Deli / Bodega  0.03
5                  Bakery  0.03
6     Fried Chicken Joint  0.03
7       Mobile Phone Shop  0.03
8             Supermarket  0.03
9      Mexican Restaurant  0.03


----Cloverdale----
                        venue  freq
0                        Park  0.33
1                Intersection  0.17
2               Moving Target  0.17
3  Construction & Landscaping  0.17
4                        Road  0.17
5                 Outlet Mall  0.00
6           Mobile Phone Shop  0.00
7                   Multiplex  0.00
8                      Museum  0.00
9     New American Restaurant  0.00


----Coffee Bluff----
                       venue  freq
0                 Playground   0.5
1            Harbor / Marina   0.5
2                Yoga Studio   0.0
3      Outdoors & Recreation   0.0
4  Middle Eastern Restaurant   0.0
5          Mobile Phone Shop   0.0
6              Moving Target   0.0
7                  Multiplex   0.0
8                     Museum   0.0
9    New American Restaurant   0.0


----Colonial Oaks----
                        venue  freq
0                        Park   0.2
1  Construction & Landscaping   0.2
2                Home Service   0.2
3                 Coffee Shop   0.2
4          Photography Studio   0.2
5       Outdoors & Recreation   0.0
6           Mobile Phone Shop   0.0
7               Moving Target   0.0
8                   Multiplex   0.0
9                      Museum   0.0


----Colonial Village----
                        venue  freq
0                        Park   0.2
1  Construction & Landscaping   0.2
2                Home Service   0.2
3                 Coffee Shop   0.2
4          Photography Studio   0.2
5       Outdoors & Recreation   0.0
6           Mobile Phone Shop   0.0
7               Moving Target   0.0
8                   Multiplex   0.0
9                      Museum   0.0


----Dawes Avenue----
                        venue  freq
0              Discount Store  0.33
1               Deli / Bodega  0.11
2                     Brewery  0.11
3  Construction & Landscaping  0.11
4              Sandwich Place  0.11
5               Grocery Store  0.11
6                      Bakery  0.11
7                 Outlet Mall  0.00
8                   Multiplex  0.00
9                      Museum  0.00


----Dixon Park----
                 venue  freq
0          Coffee Shop  0.10
1  American Restaurant  0.07
2           Restaurant  0.07
3                 Park  0.07
4        Historic Site  0.07
5            BBQ Joint  0.07
6          Yoga Studio  0.03
7         Burger Joint  0.03
8           Beer Store  0.03
9           Taco Place  0.03


----Downtown Savannah----
                             venue  freq
0                            Plaza  0.23
1                           Bistro  0.10
2                   History Museum  0.07
3  Southern / Soul Food Restaurant  0.07
4                              Pub  0.03
5                    Tour Provider  0.03
6                           Museum  0.03
7                              Gym  0.03
8                      Coffee Shop  0.03
9                        Bookstore  0.03


----East Savannah----
                           venue  freq
0                 Discount Store  0.25
1                    Supermarket  0.12
2                      BBQ Joint  0.12
3                 Ice Cream Shop  0.12
4                 Sandwich Place  0.12
5                  Grocery Store  0.12
6                    Pizza Place  0.12
7           Kitchen Supply Store  0.00
8  Paper / Office Supplies Store  0.00
9                      Multiplex  0.00


----Eastside----
                  venue  freq
0           Pizza Place  0.07
1                  Park  0.07
2        Sandwich Place  0.07
3           Coffee Shop  0.07
4    Chinese Restaurant  0.07
5        Breakfast Spot  0.03
6     Mobile Phone Shop  0.03
7  Gym / Fitness Center  0.03
8         Grocery Store  0.03
9      Greek Restaurant  0.03


----Edgemere----
                 venue  freq
0                 Park  0.24
1       Baseball Field  0.12
2          Coffee Shop  0.06
3           Playground  0.06
4         Tennis Court  0.06
5               Lawyer  0.06
6      Laundry Service  0.06
7   Salon / Barbershop  0.06
8                Plaza  0.06
9  Sporting Goods Shop  0.06


----Fairfield----
                             venue  freq
0                         Pharmacy  0.13
1                   Sandwich Place  0.10
2                      Gas Station  0.07
3                             Café  0.07
4                      Pizza Place  0.07
5              Japanese Restaurant  0.03
6                    Burrito Place  0.03
7  Southern / Soul Food Restaurant  0.03
8             Caribbean Restaurant  0.03
9                  Supplement Shop  0.03


----Fairway Oaks----
                  venue  freq
0              Pharmacy  0.14
1  Fast Food Restaurant  0.09
2        Breakfast Spot  0.05
3           Gas Station  0.05
4           Pizza Place  0.05
5                  Café  0.05
6  Caribbean Restaurant  0.05
7         Shopping Mall  0.05
8                   Gym  0.05
9         Tanning Salon  0.05


----Fernwood----
                 venue  freq
0       Discount Store  0.10
1    Convenience Store  0.10
2  American Restaurant  0.07
3           Sports Bar  0.07
4          Pizza Place  0.03
5              Theater  0.03
6            Multiplex  0.03
7           Donut Shop  0.03
8        Shopping Mall  0.03
9  Fried Chicken Joint  0.03


----Forest Park----
                             venue  freq
0                      Candy Store  0.10
1                            Plaza  0.07
2  Southern / Soul Food Restaurant  0.07
3                           Lounge  0.07
4                            Hotel  0.07
5                     Gourmet Shop  0.07
6               Seafood Restaurant  0.03
7                         Boutique  0.03
8                         Dive Bar  0.03
9                           Museum  0.03


----Forest Ridge----
                             venue  freq
0                      Candy Store  0.10
1                            Plaza  0.07
2  Southern / Soul Food Restaurant  0.07
3                           Lounge  0.07
4                            Hotel  0.07
5                     Gourmet Shop  0.07
6               Seafood Restaurant  0.03
7                         Boutique  0.03
8                         Dive Bar  0.03
9                           Museum  0.03


----Habersham Woods----
                    venue  freq
0                   Hotel  0.20
1           Grocery Store  0.07
2             Coffee Shop  0.07
3      Seafood Restaurant  0.03
4             Men's Store  0.03
5            Burger Joint  0.03
6  Furniture / Home Store  0.03
7          Shopping Plaza  0.03
8            Optical Shop  0.03
9           Women's Store  0.03


----Highland Park----
                 venue  freq
0     Asian Restaurant  0.10
1            Multiplex  0.07
2  American Restaurant  0.07
3       Ice Cream Shop  0.07
4       Sandwich Place  0.07
5     Sushi Restaurant  0.07
6                  Spa  0.03
7  Fried Chicken Joint  0.03
8       Massage Studio  0.03
9   Chinese Restaurant  0.03


----Hillcrest----
                 venue  freq
0       Cosmetics Shop  0.09
1         Intersection  0.09
2       Discount Store  0.09
3                  Gym  0.09
4            BBQ Joint  0.05
5           Sports Bar  0.05
6          Supermarket  0.05
7  Fried Chicken Joint  0.05
8   Chinese Restaurant  0.05
9   Seafood Restaurant  0.05


----Hitch Village----
               venue  freq
0              Plaza  0.23
1        Coffee Shop  0.07
2          Bookstore  0.07
3             Bistro  0.07
4  Food & Drink Shop  0.03
5     Breakfast Spot  0.03
6       Cocktail Bar  0.03
7           Tea Room  0.03
8    Bed & Breakfast  0.03
9           Fountain  0.03


----Jackson Park----
                       venue  freq
0                  BBQ Joint   0.5
1                      River   0.5
2                Outlet Mall   0.0
3  Middle Eastern Restaurant   0.0
4          Mobile Phone Shop   0.0
5              Moving Target   0.0
6                  Multiplex   0.0
7                     Museum   0.0
8    New American Restaurant   0.0
9                  Nightclub   0.0


----Kayton----
                 venue  freq
0                Plaza  0.10
1               Museum  0.07
2          Coffee Shop  0.07
3  Fried Chicken Joint  0.07
4      Bed & Breakfast  0.07
5                  Bar  0.07
6        Tour Provider  0.03
7          Gaming Cafe  0.03
8           Playground  0.03
9                  Gym  0.03


----Kensington Park----
                             venue  freq
0                            Hotel  0.10
1                             Café  0.07
2                         Pharmacy  0.07
3                    Grocery Store  0.07
4               Salon / Barbershop  0.03
5             Caribbean Restaurant  0.03
6           Furniture / Home Store  0.03
7                     Burger Joint  0.03
8  Southern / Soul Food Restaurant  0.03
9                      Pizza Place  0.03


----Laurel Grove----
                   venue  freq
0    Fried Chicken Joint   0.2
1                   Park   0.2
2                 Bakery   0.2
3      Mobile Phone Shop   0.1
4           Intersection   0.1
5          Auto Workshop   0.1
6     Seafood Restaurant   0.1
7  Outdoors & Recreation   0.0
8          Moving Target   0.0
9              Multiplex   0.0


----Live Oak----
                        venue  freq
0           Convenience Store  0.33
1  Construction & Landscaping  0.33
2                  Hobby Shop  0.33
3                 Yoga Studio  0.00
4                 Outlet Mall  0.00
5           Mobile Phone Shop  0.00
6               Moving Target  0.00
7                   Multiplex  0.00
8                      Museum  0.00
9     New American Restaurant  0.00


----Mayfair----
                      venue  freq
0    Thrift / Vintage Store  0.11
1                Kids Store  0.11
2                      Park  0.11
3                     Track  0.11
4                      Lake  0.11
5            Baseball Field  0.11
6  Bike Rental / Bike Share  0.11
7                      Pool  0.11
8                       Bar  0.11
9   New American Restaurant  0.00


----Medical Arts----
                             venue  freq
0                   Sandwich Place  0.10
1                         Pharmacy  0.10
2                             Café  0.07
3                      Pizza Place  0.07
4                      Coffee Shop  0.07
5                      Yoga Studio  0.03
6  Southern / Soul Food Restaurant  0.03
7                    Smoothie Shop  0.03
8                   Breakfast Spot  0.03
9                      Gas Station  0.03


----Metropolitan----
            venue  freq
0     Bus Station  0.14
1   Metro Station  0.09
2       Nightclub  0.09
3            Food  0.09
4     Pizza Place  0.05
5  Sandwich Place  0.05
6  Soccer Stadium  0.05
7    Soccer Field  0.05
8      Food Truck  0.05
9             Gym  0.05


----Oakdale----
                venue  freq
0            Pharmacy  0.12
1         Video Store  0.08
2       Deli / Bodega  0.04
3       Grocery Store  0.04
4  Mexican Restaurant  0.04
5           Multiplex  0.04
6        Burger Joint  0.04
7         Gas Station  0.04
8       Shopping Mall  0.04
9         Coffee Shop  0.04


----Oakhurst----
                    venue  freq
0          Sandwich Place  0.07
1          Discount Store  0.07
2  Furniture / Home Store  0.03
3             Supermarket  0.03
4        Storage Facility  0.03
5       Electronics Store  0.03
6           Smoothie Shop  0.03
7           Shopping Mall  0.03
8          Clothing Store  0.03
9           Deli / Bodega  0.03


----Oakland Park----
                           venue  freq
0                 Discount Store  0.11
1            American Restaurant  0.07
2                 Clothing Store  0.07
3                     Sports Bar  0.04
4                 Sandwich Place  0.04
5                      Multiplex  0.04
6                  Shopping Mall  0.04
7                     Shoe Store  0.04
8             Chinese Restaurant  0.04
9  Paper / Office Supplies Store  0.04


----Oglethorpe----
                             venue  freq
0                            Plaza  0.20
1                           Bistro  0.10
2                     Dessert Shop  0.07
3                      Coffee Shop  0.07
4                           Museum  0.07
5  Southern / Soul Food Restaurant  0.07
6                     Gourmet Shop  0.03
7                              Bar  0.03
8                   Cosmetics Shop  0.03
9               Persian Restaurant  0.03


----Paradise Park----
                  venue  freq
0                  Park  0.10
1    Chinese Restaurant  0.10
2     Korean Restaurant  0.07
3                Bakery  0.07
4  Fast Food Restaurant  0.07
5     Hotpot Restaurant  0.03
6                  Café  0.03
7        Shipping Store  0.03
8        Cosmetics Shop  0.03
9           Pizza Place  0.03


----Parkside----
                venue  freq
0         Golf Course  0.12
1       Bowling Alley  0.06
2  Salon / Barbershop  0.06
3             Brewery  0.06
4    Business Service  0.06
5      Shopping Plaza  0.06
6       Grocery Store  0.06
7  Chinese Restaurant  0.06
8           Locksmith  0.06
9        Liquor Store  0.06


----Pine Gardens----
                    venue  freq
0          Discount Store  0.08
1                    Park  0.08
2                Building  0.08
3             Golf Course  0.08
4  Furniture / Home Store  0.08
5                     Bar  0.08
6                    Food  0.08
7      Seafood Restaurant  0.08
8            Liquor Store  0.08
9          Clothing Store  0.08


----Poplar Place----
                       venue  freq
0             Baseball Field   1.0
1                Yoga Studio   0.0
2              Metro Station   0.0
3  Middle Eastern Restaurant   0.0
4          Mobile Phone Shop   0.0
5              Moving Target   0.0
6                  Multiplex   0.0
7                     Museum   0.0
8    New American Restaurant   0.0
9                  Nightclub   0.0


----Ridgewood----
                             venue  freq
0                      Pizza Place  0.07
1              American Restaurant  0.07
2                             Café  0.07
3                         Pharmacy  0.07
4                   Sandwich Place  0.07
5               Italian Restaurant  0.03
6  Southern / Soul Food Restaurant  0.03
7                    Smoothie Shop  0.03
8                   Shopping Plaza  0.03
9             Caribbean Restaurant  0.03


----Rivers End----
                  venue  freq
0          Intersection  0.29
1        Cosmetics Shop  0.29
2  Fast Food Restaurant  0.14
3            Playground  0.14
4             Bookstore  0.14
5           Yoga Studio  0.00
6     Mobile Phone Shop  0.00
7         Moving Target  0.00
8             Multiplex  0.00
9                Museum  0.00


----Rose Dhu----
                       venue  freq
0                 Campground   1.0
1                Yoga Studio   0.0
2      Outdoors & Recreation   0.0
3  Middle Eastern Restaurant   0.0
4          Mobile Phone Shop   0.0
5              Moving Target   0.0
6                  Multiplex   0.0
7                     Museum   0.0
8    New American Restaurant   0.0
9                  Nightclub   0.0


----Savannah Gardens----
                venue  freq
0   Convenience Store  0.22
1                Park  0.22
2         Golf Course  0.11
3  Seafood Restaurant  0.11
4                Food  0.11
5                 Bar  0.11
6        Liquor Store  0.11
7         Yoga Studio  0.00
8        Optical Shop  0.00
9       Moving Target  0.00


----Savannah State University----
                       venue  freq
0            Harbor / Marina   0.4
1         Seafood Restaurant   0.2
2        Sporting Goods Shop   0.2
3        American Restaurant   0.2
4      Outdoors & Recreation   0.0
5  Middle Eastern Restaurant   0.0
6          Mobile Phone Shop   0.0
7              Moving Target   0.0
8                  Multiplex   0.0
9                     Museum   0.0


----Shirley Park----
                venue  freq
0  Chinese Restaurant  0.17
1        Intersection  0.08
2              Bakery  0.08
3      Discount Store  0.08
4                Park  0.08
5  Seafood Restaurant  0.08
6         Gas Station  0.08
7          Sports Bar  0.08
8         Supermarket  0.08
9        Dessert Shop  0.08


----South Garden----
                             venue  freq
0                      Candy Store  0.10
1                            Plaza  0.07
2  Southern / Soul Food Restaurant  0.07
3                           Lounge  0.07
4                            Hotel  0.07
5                     Gourmet Shop  0.07
6               Seafood Restaurant  0.03
7                         Boutique  0.03
8                         Dive Bar  0.03
9                           Museum  0.03


----Southover----
                        venue  freq
0                      Bakery  0.25
1                     Brewery  0.25
2              Discount Store  0.25
3  Construction & Landscaping  0.25
4                 Yoga Studio  0.00
5               Moving Target  0.00
6                   Multiplex  0.00
7                      Museum  0.00
8     New American Restaurant  0.00
9                   Nightclub  0.00


----Sunset Park----
                  venue  freq
0            Sports Bar  0.07
1           Pizza Place  0.07
2        Discount Store  0.07
3  Fast Food Restaurant  0.07
4              Pharmacy  0.07
5   Fried Chicken Joint  0.07
6           Coffee Shop  0.07
7    Chinese Restaurant  0.03
8     Mobile Phone Shop  0.03
9        Breakfast Spot  0.03


----Sylvan Terrace----
                       venue  freq
0            Harbor / Marina  0.50
1              Boat or Ferry  0.25
2             Scenic Lookout  0.25
3               Optical Shop  0.00
4         Mexican Restaurant  0.00
5  Middle Eastern Restaurant  0.00
6          Mobile Phone Shop  0.00
7              Moving Target  0.00
8                  Multiplex  0.00
9                     Museum  0.00


----Thomas Square----
                       venue  freq
0                        Pub   0.2
1           Business Service   0.2
2                      River   0.2
3                   Pharmacy   0.2
4               Gourmet Shop   0.2
5  Middle Eastern Restaurant   0.0
6          Mobile Phone Shop   0.0
7              Moving Target   0.0
8                  Multiplex   0.0
9                     Museum   0.0


----Tremont Park----
                        venue  freq
0  Construction & Landscaping  0.15
1                 Gas Station  0.15
2              Discount Store  0.15
3           Convenience Store  0.08
4        Fast Food Restaurant  0.08
5               Grocery Store  0.08
6               Deli / Bodega  0.08
7                    Wine Bar  0.08
8                Intersection  0.08
9                        Food  0.08


----Victory Heights----
                  venue  freq
0           Pizza Place  0.07
1              Pharmacy  0.07
2  Fast Food Restaurant  0.07
3           Coffee Shop  0.07
4     Mobile Phone Shop  0.07
5    Chinese Restaurant  0.07
6        General Travel  0.03
7         Grocery Store  0.03
8            Sports Bar  0.03
9            Donut Shop  0.03


----Victory Manor----
                  venue  freq
0           Pizza Place  0.07
1    Mexican Restaurant  0.07
2        Sandwich Place  0.07
3    Chinese Restaurant  0.07
4           Coffee Shop  0.07
5      Greek Restaurant  0.03
6   Fried Chicken Joint  0.03
7  Gym / Fitness Center  0.03
8         Grocery Store  0.03
9        Breakfast Spot  0.03


----Victory Square----
                  venue  freq
0           Pizza Place  0.07
1              Pharmacy  0.07
2  Fast Food Restaurant  0.07
3           Coffee Shop  0.07
4     Mobile Phone Shop  0.07
5    Chinese Restaurant  0.07
6        General Travel  0.03
7         Grocery Store  0.03
8            Sports Bar  0.03
9            Donut Shop  0.03


----West Savannah----
                           venue  freq
0                 Discount Store  0.25
1                    Supermarket  0.12
2                      BBQ Joint  0.12
3                 Ice Cream Shop  0.12
4                 Sandwich Place  0.12
5                  Grocery Store  0.12
6                    Pizza Place  0.12
7           Kitchen Supply Store  0.00
8  Paper / Office Supplies Store  0.00
9                      Multiplex  0.00


----Windsor Forest----
                      venue  freq
0              Intersection  0.08
1                 BBQ Joint  0.08
2               Pizza Place  0.08
3         Convenience Store  0.08
4            Sandwich Place  0.08
5      Fast Food Restaurant  0.08
6                  Building  0.08
7               Gas Station  0.08
8  Mediterranean Restaurant  0.08
9             Grocery Store  0.08


----Winter Gardens----
                       venue  freq
0                       Pool  0.25
1               Soccer Field  0.25
2           Video Game Store  0.25
3                        Gym  0.25
4               Optical Shop  0.00
5  Middle Eastern Restaurant  0.00
6          Mobile Phone Shop  0.00
7              Moving Target  0.00
8                  Multiplex  0.00
9                     Museum  0.00


----Yamacraw Village----
                             venue  freq
0                           Museum  0.10
1                            Plaza  0.10
2                     Dessert Shop  0.07
3                            Hotel  0.07
4       Tourist Information Center  0.07
5                           Lounge  0.03
6  Southern / Soul Food Restaurant  0.03
7                             Café  0.03
8                          Brewery  0.03
9                     Gourmet Shop  0.03

Jacksonville Venue Frequency¶

num_top_venues = 10
for hood in A_grouped['Neighborhood']:
    print("----"+hood+"----")
    temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
    temp.columns = ['venue','freq']
    temp = temp.iloc[1:]
    temp['freq'] = temp['freq'].astype(float)
    temp = temp.round({'freq': 2})
    print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
    print('\n')

----Arlington----
                 venue  freq
0          Video Store  0.09
1                  ATM  0.04
2          Gas Station  0.04
3    Convenience Store  0.04
4       Sandwich Place  0.04
5           Restaurant  0.04
6       Discount Store  0.04
7           Donut Shop  0.04
8  Fried Chicken Joint  0.04
9            Nightclub  0.04


----Avondale----
                venue  freq
0          Smoke Shop  0.08
1         Pizza Place  0.08
2  Mexican Restaurant  0.04
3  Chinese Restaurant  0.04
4         Coffee Shop  0.04
5                Park  0.04
6          Sports Bar  0.04
7         Gaming Cafe  0.04
8             Brewery  0.04
9      Breakfast Spot  0.04


----Belfort Station----
                  venue  freq
0        Sandwich Place  0.11
1           IT Services  0.11
2                 Hotel  0.11
3    Italian Restaurant  0.06
4           Gas Station  0.06
5    Chinese Restaurant  0.06
6          Cocktail Bar  0.06
7    Mexican Restaurant  0.06
8                   Gym  0.06
9  Gym / Fitness Center  0.06


----Brooklyn----
                        venue  freq
0                        Café  0.10
1                        Park  0.07
2               Deli / Bodega  0.07
3               Burrito Place  0.03
4               Smoothie Shop  0.03
5                     Gay Bar  0.03
6  Construction & Landscaping  0.03
7               Grocery Store  0.03
8                Burger Joint  0.03
9                         Gym  0.03


----Church District----
                 venue  freq
0          Pizza Place  0.08
1   Salon / Barbershop  0.08
2  Japanese Restaurant  0.08
3        Grocery Store  0.08
4   Chinese Restaurant  0.04
5        Shopping Mall  0.04
6       Shop & Service  0.04
7       Shipping Store  0.04
8       Sandwich Place  0.04
9           Restaurant  0.04


----Downtown----
                     venue  freq
0              Coffee Shop  0.10
1               Steakhouse  0.07
2              Art Gallery  0.07
3                     Café  0.07
4                   Lounge  0.07
5           Sandwich Place  0.03
6            Burrito Place  0.03
7                Speakeasy  0.03
8  Comfort Food Restaurant  0.03
9             Concert Hall  0.03


----East Jacksonville----
                  venue  freq
0  Fast Food Restaurant  0.38
1           Video Store  0.12
2         Train Station  0.12
3        Sandwich Place  0.12
4    Light Rail Station  0.12
5                Bakery  0.12
6                   ATM  0.00
7             Pet Store  0.00
8             Nightclub  0.00
9  Other Great Outdoors  0.00


----Empire Point----
                 venue  freq
0          Gas Station  0.17
1           Donut Shop  0.17
2  Rental Car Location  0.17
3       Baseball Field  0.17
4               Lawyer  0.17
5  American Restaurant  0.17
6                Plaza  0.00
7           Playground  0.00
8          Pizza Place  0.00
9   Photography Studio  0.00


----Mandarin----
                   venue  freq
0       Business Service  0.29
1      Electronics Store  0.14
2       Volleyball Court  0.14
3             Food Truck  0.14
4                   Park  0.14
5              Pet Store  0.14
6                    ATM  0.00
7   Other Great Outdoors  0.00
8  Outdoors & Recreation  0.00
9               Pharmacy  0.00


----North Jacksonville----
                  venue  freq
0  Fast Food Restaurant  0.38
1           Video Store  0.12
2         Train Station  0.12
3        Sandwich Place  0.12
4    Light Rail Station  0.12
5                Bakery  0.12
6                   ATM  0.00
7             Pet Store  0.00
8             Nightclub  0.00
9  Other Great Outdoors  0.00


----Oakland----
                   venue  freq
0                    Bar  0.10
1    Rental Car Location  0.07
2                   Park  0.07
3      Convenience Store  0.07
4           Tennis Court  0.03
5          Grocery Store  0.03
6  General Entertainment  0.03
7             Sports Bar  0.03
8                   Café  0.03
9          Burrito Place  0.03


----Ortega----
                     venue  freq
0          Harbor / Marina  0.29
1      American Restaurant  0.14
2             Home Service  0.14
3                    Trail  0.14
4                     Park  0.14
5            Jewelry Store  0.14
6                 Pharmacy  0.00
7  New American Restaurant  0.00
8                Nightclub  0.00
9     Other Great Outdoors  0.00


----River Park----
               venue  freq
0        Coffee Shop  0.10
1        Art Gallery  0.07
2               Café  0.07
3       Dessert Shop  0.03
4   Sushi Restaurant  0.03
5         Food Truck  0.03
6            Dog Run  0.03
7                Pub  0.03
8     Sandwich Place  0.03
9  Convenience Store  0.03


----Riverside----
                 venue  freq
0           Restaurant  0.07
1       Sandwich Place  0.07
2  American Restaurant  0.07
3     Sushi Restaurant  0.07
4                  Bar  0.07
5          Coffee Shop  0.07
6        Grocery Store  0.03
7                  Spa  0.03
8           Taco Place  0.03
9                  Gym  0.03


----San Marco----
                      venue  freq
0               Coffee Shop  0.10
1       American Restaurant  0.07
2            Sandwich Place  0.07
3  Mediterranean Restaurant  0.07
4       Indie Movie Theater  0.03
5                      Park  0.03
6                      Café  0.03
7                 Speakeasy  0.03
8       Sporting Goods Shop  0.03
9                Donut Shop  0.03


----Sherwood Forest----
                     venue  freq
0           Discount Store   0.5
1                Gift Shop   0.5
2                      ATM   0.0
3                Pet Store   0.0
4  New American Restaurant   0.0
5                Nightclub   0.0
6     Other Great Outdoors   0.0
7    Outdoors & Recreation   0.0
8                     Park   0.0
9                 Pharmacy   0.0


----South Jacksonville----
                      venue  freq
0                     Hotel  0.07
1               Coffee Shop  0.07
2        Mexican Restaurant  0.07
3            Sandwich Place  0.07
4  Mediterranean Restaurant  0.07
5                   Brewery  0.03
6                      Café  0.03
7                Sports Bar  0.03
8              Cocktail Bar  0.03
9      Gym / Fitness Center  0.03


----South Side----
                 venue  freq
0                 Park  0.14
1   Salon / Barbershop  0.09
2       Baseball Field  0.09
3          Pizza Place  0.09
4  Japanese Restaurant  0.05
5        Grocery Store  0.05
6         Soccer Field  0.05
7            Disc Golf  0.05
8   Chinese Restaurant  0.05
9      Supplement Shop  0.05


----Springfield----
                 venue  freq
0                  Zoo   0.2
1        Auto Workshop   0.2
2              Exhibit   0.2
3             Tea Room   0.2
4        Deli / Bodega   0.2
5   Italian Restaurant   0.0
6  Japanese Restaurant   0.0
7  Rental Car Location   0.0
8          Record Shop   0.0
9                  Pub   0.0


----Stadium District----
                   venue  freq
0            Pizza Place  0.14
1                    ATM  0.07
2                Stadium  0.07
3  Outdoors & Recreation  0.07
4  General Entertainment  0.07
5   Fast Food Restaurant  0.07
6         Baseball Field  0.07
7                    Gym  0.07
8            Coffee Shop  0.07
9         Shipping Store  0.07


----Waterleaf----
                venue  freq
0       Hot Dog Joint  0.17
1        Intersection  0.17
2                Pool  0.17
3  Photography Studio  0.17
4                 Gym  0.17
5           Rest Area  0.17
6  Italian Restaurant  0.00
7           Nightclub  0.00
8         Record Shop  0.00
9                 Pub  0.00


----West Jacksonville----
                        venue  freq
0        Caribbean Restaurant  0.14
1                Intersection  0.14
2                Home Service  0.14
3              Cosmetics Shop  0.14
4              Sandwich Place  0.14
5  Construction & Landscaping  0.14
6                   Cafeteria  0.14
7                         ATM  0.00
8                        Park  0.00
9                   Pet Store  0.00

from IPython.display import Image

Queens=Image(filename='/home/jovyan/demo/JHU_COVID-19_Queens.png') 
Queens

Duval=Image(filename='/home/jovyan/demo/JHU_COVID-19_Duval.png') 
Duval

Chatham=Image(filename='/home/jovyan/demo/JHU_COVID-19_Chatham.png') 
Chatham

	Neighborhood	Neighborhood Latitude	Neighborhood Longitude	Venue	Venue Latitude	Venue Longitude	Venue Category
0	Avalon	32.05001	-81.066843	GameStop	32.044100	-81.068130	Video Game Store
1	Avalon	32.05001	-81.066843	Whole Foods Market	32.043391	-81.071361	Grocery Store
2	Avalon	32.05001	-81.066843	Hop Xing	32.044566	-81.067693	Chinese Restaurant
3	Avalon	32.05001	-81.066843	Firehouse Subs	32.041880	-81.066176	Sandwich Place
4	Avalon	32.05001	-81.066843	Sisters Of The New South	32.042652	-81.063602	Restaurant

	Unnamed: 0	Duval (DU) , FL	Chatham (CA) , GA
0	Demographics
1	Population	950,181	289,195
2	% below 18 years of age	22.60%	21.20%
3	% 65 and older	14.00%	15.40%
4	% Non-Hispanic Black	29.50%	40.10%

	Unnamed: 0	Duval (DU) , FL	Chatham (CA) , GA
0	Demographics
1	Population	950,181	289,195
2	% below 18 years of age	22.60%	21.20%
3	% 65 and older	14.00%	15.40%
4	% Non-Hispanic Black	29.50%	40.10%
5	% American Indian & Alaska Native	0.50%	0.40%
6	% Asian	5.10%	2.90%
7	% Native Hawaiian/Other Pacific Islander	0.10%	0.10%
8	% Hispanic	10.10%	6.60%
9	% Non-Hispanic White	52.60%	48.20%
10	% not proficient in English	3%	1%
11	% Females	51.50%	51.90%
12	% Rural	2.90%	4.50%
13	Length of Life
14	Life expectancy	76.2	77.9
15	Premature age-adjusted mortality	440	400
16	Child mortality	80	80
17	Infant mortality	9	7
18	Quality of Life
19	Frequent physical distress	13%	11%
20	Frequent mental distress	13%	12%
21	Diabetes prevalence	12%	10%
22	HIV prevalence	761	702
23	Health Behaviors
24	Food insecurity	18%	17%
25	Limited access to healthy foods	9%	7%
26	Drug overdose deaths	41	13
27	Motor vehicle crash deaths	15	12
28	Insufficient sleep	37%	38%
29	Clinical Care
...	...	...	...
46	Traffic volume	422	362
47	Homeownership	57%	54%
48	Severe housing cost burden	16%	17%
49	Health Outcomes
50	Length of Life
51	Premature death	9,700	8,300
52	Quality of Life
53	Poor or fair health	19%	18%
54	Poor physical health days	4.3	3.4
55	Poor mental health days	4.3	3.7
56	Low birthweight	10%	10%
57	Health Factors
58	Health Behaviors
59	Adult smoking	20%	17%
60	Adult obesity	31%	32%
61	Food environment index	6.6	6.9
62	Physical inactivity	26%	26%
63	Access to exercise opportunities	92%	90%
64	Excessive drinking	19%	17%
65	Alcohol-impaired driving deaths	29%	21%
66	Sexually transmitted infections	738.3	876.8
67	Teen births	29	25
68	Clinical Care
69	Uninsured	13%	16%
70	Primary care physicians	1,160:1	1,130:1
71	Dentists	1,220:1	1,500:1
72	Mental health providers	510:01:00	690:01:00
73	Preventable hospital stays	5,911	4,502
74	Mammography screening	41%	47%
75	Flu vaccinations	43%	45%

	AGE	Number of Deaths	Share of deaths	With underlying conditions	Without underlying conditions	Unknown if with underlying cond.	Share of deaths of unknown + w/o cond.
0	0 - 17 years old	9	0.06%	6	3	0	0.02%
1	18 - 44 years old	601	3.90%	476	17	108	0.80%
2	45 - 64 years old	3,413	22.40%	2,851	72	490	3.70%
3	65 - 74 years old	3,788	24.90%	2,801	5	982	6.50%
4	75+ years old	7,419	48.70%	5,236	2	2,181	14.30%
5	TOTAL	15,230	100%	11,370 (75%)	99 (0.7%)	1,551 (24.7%)	25.30%

	Description	Duval	Chatham	Queens
0	Number of Beds	3,456	1,569	3,210
1	Cases per 100,000	128	119	2,521
2	Confirmed Cases	1,215	344	57,459
3	Deaths	32	14	4,595
4	Fatality Rate	2.6%	4%	8%

	City	Neighborhood	Latitude	Longitude
0	Savannah	Avalon	32.050010	-81.066843
1	Savannah	Avondale	32.052988	-81.057612
2	Savannah	Baldwin Park	32.050870	-81.091097
3	Savannah	Bartow	32.086596	-81.124556
4	Savannah	Bayview	30.224534	-85.682356

	City	Neighborhood	Latitude	Longitude
0	Jacksonville	Arlington	30.335795	-81.602871
1	Jacksonville	Avondale	30.304406	-81.711209
2	Jacksonville	Belfort Station	30.251119	-81.584455
3	Jacksonville	Brooklyn	30.323573	-81.674541
4	Jacksonville	Church District	30.280525	-81.490998

	Neighborhood	American Restaurant	Antique Shop	Bank	Big Box Store	Breakfast Spot	Café	Chinese Restaurant	Coffee Shop	Construction & Landscaping	Convenience Store	Cosmetics Shop	Deli / Bodega	Discount Store	Drive-in Theater	Fast Food Restaurant	Food	Fried Chicken Joint	Garden	Gas Station	General Travel	Gift Shop	Greek Restaurant	Grocery Store	Gym / Fitness Center	Hardware Store	Historic Site	Home Service	Ice Cream Shop	Intersection	Kids Store	Liquor Store	Lounge	Mexican Restaurant	Middle Eastern Restaurant	Mobile Phone Shop	Park	Pet Store	Pharmacy	Pizza Place	Playground	Plaza	Pool	Pub	Rental Car Location	Restaurant	Salon / Barbershop	Sandwich Place	Seafood Restaurant	Shipping Store	Skating Rink	Southern / Soul Food Restaurant	Sporting Goods Shop	Tour Provider	Video Game Store	Video Store
0	Avalon	0.000000	0.000000	0.033333	0.033333	0.033333	0.000000	0.066667	0.000000	0.00	0.000000	0.000000	0.033333	0.033333	0.00	0.033333	0.000000	0.033333	0.00	0.0	0.000000	0.000000	0.033333	0.033333	0.033333	0.033333	0.000000	0.033333	0.033333	0.000000	0.00	0.000000	0.000000	0.066667	0.000000	0.066667	0.033333	0.033333	0.033333	0.066667	0.000000	0.000000	0.000000	0.000000	0.033333	0.033333	0.000000	0.066667	0.000000	0.0	0.000000	0.000000	0.000000	0.000000	0.033333	0.033333
1	Avondale	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.00	0.071429	0.000000	0.000000	0.000000	0.00	0.071429	0.142857	0.000000	0.00	0.0	0.071429	0.000000	0.000000	0.000000	0.000000	0.000000	0.071429	0.000000	0.000000	0.071429	0.00	0.071429	0.000000	0.000000	0.000000	0.000000	0.142857	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.071429	0.0	0.071429	0.000000	0.071429	0.071429	0.000000	0.000000
2	Baldwin Park	0.066667	0.033333	0.000000	0.000000	0.000000	0.033333	0.000000	0.033333	0.00	0.000000	0.033333	0.000000	0.000000	0.00	0.000000	0.000000	0.000000	0.00	0.1	0.000000	0.033333	0.033333	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.066667	0.00	0.000000	0.033333	0.000000	0.033333	0.000000	0.100000	0.033333	0.000000	0.000000	0.066667	0.033333	0.033333	0.033333	0.000000	0.033333	0.033333	0.000000	0.033333	0.0	0.000000	0.066667	0.033333	0.000000	0.000000	0.000000
3	Bartow	0.100000	0.000000	0.000000	0.000000	0.000000	0.000000	0.100000	0.000000	0.00	0.000000	0.000000	0.000000	0.200000	0.00	0.000000	0.000000	0.000000	0.00	0.0	0.000000	0.000000	0.000000	0.100000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.00	0.000000	0.000000	0.000000	0.000000	0.000000	0.100000	0.200000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.100000	0.1	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000
4	Bayview	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.25	0.000000	0.000000	0.000000	0.000000	0.25	0.000000	0.000000	0.000000	0.25	0.0	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.25	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.0	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000

	Neighborhood	ATM	American Restaurant	Arcade	Art Museum	Arts & Crafts Store	Automotive Shop	Bakery	Bank	Bar	Boat or Ferry	Breakfast Spot	Brewery	Bridal Shop	Burger Joint	Burrito Place	Café	Chinese Restaurant	Cocktail Bar	Coffee Shop	Concert Hall	Construction & Landscaping	Convenience Store	Deli / Bodega	Dentist's Office	Dessert Shop	Discount Store	Doctor's Office	Donut Shop	French Restaurant	Fried Chicken Joint	Gaming Cafe	Garden Center	Gas Station	Gay Bar	Grocery Store	Gym	Gym / Fitness Center	Harbor / Marina	Health & Beauty Service	Heliport	Historic Site	Home Service	Hookah Bar	Hotel	Hotel Pool	IT Services	Ice Cream Shop	Intersection	Italian Restaurant	Japanese Restaurant	Jewelry Store	Liquor Store	Mediterranean Restaurant	Mexican Restaurant	Music Venue	New American Restaurant	Nightclub	Park	Pharmacy	Pizza Place	Playground	Plaza	Restaurant	Salon / Barbershop	Sandwich Place	Shipping Store	Shop & Service	Shopping Mall	Smoke Shop	Smoothie Shop	Spa	Sports Bar	Thai Restaurant	Thrift / Vintage Store	Video Store	Vietnamese Restaurant	Wings Joint
0	Arlington	0.043478	0.043478	0.000000	0.000000	0.000000	0.043478	0.000000	0.000000	0.000000	0.043478	0.000000	0.000000	0.00	0.000000	0.000000	0.0	0.000000	0.043478	0.000000	0.000000	0.000000	0.043478	0.000000	0.00	0.000000	0.043478	0.000000	0.043478	0.000000	0.043478	0.000000	0.000000	0.043478	0.000000	0.000000	0.000000	0.000000	0.043478	0.000000	0.000000	0.000000	0.000000	0.043478	0.000000	0.000000	0.043478	0.00	0.000000	0.043478	0.000000	0.000000	0.00	0.000000	0.043478	0.043478	0.000000	0.043478	0.000000	0.00	0.000000	0.000000	0.000000	0.043478	0.00	0.043478	0.00	0.00	0.043478	0.000000	0.000000	0.00	0.000000	0.00	0.043478	0.086957	0.00	0.000000
1	Avondale	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.041667	0.000000	0.041667	0.000000	0.041667	0.041667	0.00	0.000000	0.000000	0.0	0.041667	0.000000	0.041667	0.000000	0.000000	0.041667	0.041667	0.00	0.000000	0.000000	0.000000	0.000000	0.041667	0.000000	0.041667	0.041667	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.041667	0.041667	0.000000	0.000000	0.000000	0.000000	0.00	0.000000	0.000000	0.000000	0.041667	0.00	0.000000	0.041667	0.000000	0.041667	0.000000	0.041667	0.00	0.083333	0.000000	0.000000	0.041667	0.00	0.000000	0.00	0.00	0.000000	0.083333	0.000000	0.00	0.041667	0.00	0.000000	0.000000	0.00	0.041667
2	Belfort Station	0.000000	0.000000	0.055556	0.000000	0.000000	0.000000	0.000000	0.055556	0.000000	0.000000	0.000000	0.000000	0.00	0.000000	0.000000	0.0	0.055556	0.055556	0.000000	0.000000	0.000000	0.000000	0.000000	0.00	0.000000	0.000000	0.055556	0.000000	0.000000	0.000000	0.000000	0.000000	0.055556	0.000000	0.000000	0.055556	0.055556	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.111111	0.055556	0.111111	0.00	0.000000	0.055556	0.055556	0.000000	0.00	0.000000	0.055556	0.000000	0.000000	0.000000	0.000000	0.00	0.000000	0.000000	0.000000	0.000000	0.00	0.111111	0.00	0.00	0.000000	0.000000	0.000000	0.00	0.000000	0.00	0.000000	0.000000	0.00	0.000000
3	Brooklyn	0.000000	0.000000	0.000000	0.033333	0.033333	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.00	0.033333	0.033333	0.1	0.000000	0.000000	0.000000	0.033333	0.033333	0.000000	0.066667	0.00	0.033333	0.000000	0.033333	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.033333	0.033333	0.033333	0.033333	0.000000	0.033333	0.033333	0.033333	0.000000	0.000000	0.000000	0.000000	0.000000	0.00	0.033333	0.000000	0.000000	0.000000	0.00	0.033333	0.033333	0.000000	0.000000	0.000000	0.066667	0.00	0.000000	0.033333	0.033333	0.000000	0.00	0.033333	0.00	0.00	0.000000	0.000000	0.033333	0.00	0.000000	0.00	0.033333	0.000000	0.00	0.000000
4	Church District	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.040000	0.000000	0.000000	0.000000	0.000000	0.000000	0.04	0.000000	0.000000	0.0	0.040000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.04	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.080000	0.040000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.04	0.040000	0.000000	0.080000	0.000000	0.04	0.000000	0.000000	0.000000	0.000000	0.000000	0.000000	0.04	0.080000	0.000000	0.000000	0.040000	0.08	0.040000	0.04	0.04	0.040000	0.000000	0.000000	0.04	0.000000	0.04	0.000000	0.000000	0.04	0.000000

	Neighborhood	1st Most Common Venue	2nd Most Common Venue	3rd Most Common Venue	4th Most Common Venue	5th Most Common Venue	6th Most Common Venue	7th Most Common Venue	8th Most Common Venue	9th Most Common Venue	10th Most Common Venue
0	Avalon	Mobile Phone Shop	Pizza Place	Chinese Restaurant	Mexican Restaurant	Sandwich Place	Hardware Store	Fried Chicken Joint	Breakfast Spot	Fast Food Restaurant	Rental Car Location
1	Avondale	Park	Food	Sporting Goods Shop	Tour Provider	Seafood Restaurant	Fast Food Restaurant	Skating Rink	Liquor Store	General Travel	Convenience Store
2	Baldwin Park	Gas Station	Park	Intersection	Playground	Southern / Soul Food Restaurant	American Restaurant	Seafood Restaurant	Restaurant	Salon / Barbershop	Sporting Goods Shop
3	Bartow	Pet Store	Discount Store	Grocery Store	Seafood Restaurant	American Restaurant	Park	Chinese Restaurant	Shipping Store	Food & Drink Shop	Food
4	Bayview	Construction & Landscaping	Garden	Kids Store	Drive-in Theater	Women's Store	Electronics Store	French Restaurant	Fountain	Food Truck	Food & Drink Shop
5	Beach Institute	Plaza	Park	Bed & Breakfast	Hotel Bar	Tea Room	Hotel	Italian Restaurant	Fountain	Farmers Market	Dive Bar
6	Berkshire Woods	Park	Home Service	Photography Studio	Coffee Shop	Women's Store	Drive-in Theater	Fountain	Food Truck	Food & Drink Shop	Food
7	Bingville	Convenience Store	Park	Discount Store	Mexican Restaurant	Electronics Store	Bar	Fast Food Restaurant	Bistro	Chinese Restaurant	Grocery Store
8	Blueberry Hill	Farm	Women's Store	Wings Joint	Fried Chicken Joint	French Restaurant	Fountain	Food Truck	Food & Drink Shop	Food	Fast Food Restaurant
9	Brookview	Chinese Restaurant	Intersection	Construction & Landscaping	Furniture / Home Store	Food & Drink Shop	Food	Golf Course	Thrift / Vintage Store	Southern / Soul Food Restaurant	Farm

	Neighborhood	1st Most Common Venue	2nd Most Common Venue	3rd Most Common Venue	4th Most Common Venue	5th Most Common Venue	6th Most Common Venue	7th Most Common Venue	8th Most Common Venue	9th Most Common Venue	10th Most Common Venue
0	Arlington	Video Store	Restaurant	ATM	Italian Restaurant	Mexican Restaurant	Shopping Mall	Seafood Restaurant	Sandwich Place	Fried Chicken Joint	Bookstore
1	Avondale	Park	Pizza Place	Convenience Store	Gaming Cafe	Plaza	Deli / Bodega	New American Restaurant	Coffee Shop	Chinese Restaurant	Smoke Shop
2	Belfort Station	Hotel	Sandwich Place	Automotive Shop	Cocktail Bar	Chinese Restaurant	Food Truck	Gas Station	Japanese Restaurant	Italian Restaurant	Mexican Restaurant
3	Brooklyn	Café	Park	Deli / Bodega	Gym / Fitness Center	Gym	Smoothie Shop	Sandwich Place	Concert Hall	Plaza	Playground
4	Church District	Grocery Store	Pizza Place	Japanese Restaurant	Intersection	Spa	Shopping Mall	Pharmacy	Liquor Store	Shipping Store	Sandwich Place
5	Downtown	Bakery	History Museum	Truck Stop	Gas Station	Bar	Italian Restaurant	Greek Restaurant	Rest Area	American Restaurant	Dive Bar
6	East Jacksonville	Fast Food Restaurant	Video Store	Light Rail Station	Train Station	Sandwich Place	Bakery	Zoo	Event Service	Flea Market	Farmers Market
7	Empire Point	Chiropractor	Lawyer	American Restaurant	Rental Car Location	Gas Station	Baseball Field	Donut Shop	Flea Market	Fast Food Restaurant	Farmers Market
8	Mandarin	Event Service	Pet Store	Business Service	Farmers Market	Park	Food Truck	Flea Market	Fast Food Restaurant	Exhibit	Zoo
9	North Jacksonville	Fast Food Restaurant	Video Store	Light Rail Station	Train Station	Sandwich Place	Bakery	Zoo	Event Service	Flea Market	Farmers Market

	City	Neighborhood	Latitude	Longitude
0	Savannah	Avalon	32.050010	-81.066843
1	Savannah	Avondale	32.052988	-81.057612
2	Savannah	Baldwin Park	32.050870	-81.091097
3	Savannah	Bartow	32.086596	-81.124556
4	Savannah	Bayview	30.224534	-85.682356
5	Savannah	Beach Institute	32.068951	-81.089268
6	Savannah	Berkshire Woods	31.961601	-81.153999
7	Savannah	Bingville	32.046542	-81.109500
8	Savannah	Blueberry Hill	32.344312	-80.886251
9	Savannah	Brookview	32.004379	-81.074279
10	Savannah	Cann Park	32.053430	-81.113216
11	Savannah	Carver Heights	32.060826	-81.099685
12	Savannah	Chatham Crescent	32.050783	-81.096504
13	Savannah	Chatham Parkway	32.062359	-81.160074
14	Savannah	Chippewa	31.998822	-81.116223
15	Savannah	Cloverdale	32.066874	-81.129001
16	Savannah	Coffee Bluff	31.936879	-81.153165
17	Savannah	Colonial Oaks	31.962156	-81.148444
18	Savannah	Colonial Village	31.962156	-81.148444
19	Savannah	Dawes Avenue	32.055294	-81.126188
20	Savannah	Dixon Park	32.060809	-81.090965
21	Savannah	Downtown Savannah	32.075275	-81.098580
22	Savannah	East Savannah	39.941368	-94.829946
23	Savannah	Eastside	32.046452	-81.066779
24	Savannah	Edgemere	32.039377	-81.087612
25	Savannah	Fairfield	32.032710	-81.090667
26	Savannah	Fairway Oaks	32.019933	-81.095945
27	Savannah	Fernwood	32.032155	-81.064279
28	Savannah	Forest Park	32.080926	-81.091177
29	Savannah	Forest Ridge	32.080926	-81.091177
30	Savannah	Habersham Woods	32.019655	-81.107056
31	Savannah	Highland Park	32.009656	-81.100390
32	Savannah	Hillcrest	37.727200	-84.269892
33	Savannah	Hitch Village	32.073000	-81.094000
34	Savannah	Jackson Park	35.309266	-83.259593
35	Savannah	Kayton	32.069785	-81.104518
36	Savannah	Kensington Park	32.023544	-81.101779
37	Savannah	Laurel Grove	32.063056	-81.111917
38	Savannah	Live Oak	32.083880	-81.195388
39	Savannah	Mayfair	31.992990	-81.094278